﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using DTO;

namespace DAO
{
    public class hoadon_DAO
    {
        public static DataSet loadthongtinhoadon(phong_DTO p)
        {
            string sql = "select p.map,lp.tenloaip,kh.tenkh,kh.ngaydat,kh.ngaytra,lp.dongia, from phong p, loaiphong lp,khachhang kh,hoadon hd where p.maloaip=lp.maloaip and hd.makh=kh.makh and hd.map=p.map and map="+p.map+"";
            DataSet ds = new DataSet();
            ds = dataconnect.laydulieu(sql);
            return ds;
        }
    }
}
